| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Financial Pro Forma | |||||||||||||||||||||||||||||||||||
2 | Jan , 25 | Feb , 25 | Mar , 25 | Apr , 25 | May , 25 | Jun , 25 | Jul , 25 | Aug , 25 | Sep , 25 | Oct , 25 | Nov , 25 | Dec , 25 | Jan , 26 | Feb , 26 | Mar , 26 | Apr , 26 | May , 26 | Jun , 26 | Jul , 26 | Aug , 26 | Sep , 26 | Oct , 26 | Nov , 26 | Dec , 26 | Jan , 27 | Feb , 27 | Mar , 27 | Apr , 27 | May , 27 | Jun , 27 | Jul , 27 | Aug , 27 | Sep , 27 | Oct , 27 | Nov , 27 | |
3 | Year 1 | Year 2 | Year 3 | |||||||||||||||||||||||||||||||||
4 | Revenue | Development & Preparation Phase | Product Launch Phase | Sponsorship Phase | Scaling Phase | Ideal Projection Phase | Expansion Phase | |||||||||||||||||||||||||||||
5 | Units Sold | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 10 | 12 | 15 | 18 | 20 | 25 | 30 | 40 | 50 | 60 | 80 | 100 | 120 | 140 | 160 | 180 | 200 | 220 | 240 | 260 | 280 | 300 | 320 | 340 | 360 | 380 | 400 |
6 | Product Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $22,400 | $28,000 | $33,600 | $42,000 | $50,400 | $56,000 | $70,000 | $84,000 | $112,000 | $140,000 | $168,000 | $224,000 | $280,000 | $336,000 | $392,000 | $448,000 | $504,000 | $560,000 | $616,000 | $672,000 | $728,000 | $784,000 | $840,000 | $896,000 | $952,000 | $1,008,000 | $1,064,000 | $1,120,000 |
7 | Add-on Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,240 | $2,800 | $3,360 | $4,200 | $5,040 | $5,600 | $7,000 | $8,400 | $11,200 | $14,000 | $16,800 | $22,400 | $28,000 | $33,600 | $39,200 | $44,800 | $50,400 | $84,000 | $92,400 | $100,800 | $109,200 | $117,600 | $126,000 | $134,400 | $142,800 | $151,200 | $159,600 | $168,000 |
8 | Total Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $24,640 | $30,800 | $36,960 | $46,200 | $55,440 | $61,600 | $77,000 | $92,400 | $123,200 | $154,000 | $184,800 | $246,400 | $308,000 | $369,600 | $431,200 | $492,800 | $554,400 | $644,000 | $708,400 | $772,800 | $837,200 | $901,600 | $966,000 | $1,030,400 | $1,094,800 | $1,159,200 | $1,223,600 | $1,288,000 |
9 | ||||||||||||||||||||||||||||||||||||
10 | Expenses (Cost of Goods Sold) | |||||||||||||||||||||||||||||||||||
11 | Manufacturing Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $11,200 | $14,000 | $16,800 | $21,000 | $25,200 | $28,000 | $35,000 | $42,000 | $56,000 | $70,000 | $84,000 | $112,000 | $140,000 | $168,000 | $196,000 | $224,000 | $252,000 | $280,000 | $308,000 | $336,000 | $364,000 | $392,000 | $420,000 | $448,000 | $476,000 | $504,000 | $532,000 | $560,000 |
12 | Shipping & Logistics | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,000 | $2,500 | $3,000 | $3,500 | $4,000 | $4,000 | $5,000 | $6,000 | $8,000 | $10,000 | $12,000 | $16,000 | $20,000 | $24,000 | $28,000 | $32,000 | $360,000 | $30,000 | $33,000 | $36,000 | $39,000 | $42,000 | $45,000 | $48,000 | $51,000 | $54,000 | $57,000 | $60,000 |
13 | Product Development | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
14 | Total COGS | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $13,200 | $16,500 | $19,800 | $24,500 | $29,200 | $32,000 | $40,000 | $48,000 | $64,000 | $80,000 | $96,000 | $128,000 | $160,000 | $192,000 | $224,000 | $256,000 | $612,000 | $310,000 | $341,000 | $372,000 | $403,000 | $434,000 | $465,000 | $496,000 | $527,000 | $558,000 | $589,000 | $620,000 |
15 | ||||||||||||||||||||||||||||||||||||
16 | SG&A (Operating Expenses) | |||||||||||||||||||||||||||||||||||
17 | Marketing | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $4,000 | $5,000 | $6,000 | $7,000 | $8,000 | $8,000 | $9,000 | $10,000 | $12,000 | $14,000 | $16,000 | $20,000 | $24,000 | $28,000 | $32,000 | $360,000 | $400,000 | $50,000 | $55,000 | $60,000 | $65,000 | $70,000 | $75,000 | $80,000 | $85,000 | $90,000 | $95,000 | $100,000 |
18 | Operations | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $5,000 | $5,000 | $6,000 | $6,000 | $7,000 | $7,000 | $8,000 | $8,000 | $9,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
19 | Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
20 | Total SG&A | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $8,000 | $9,000 | $10,000 | $11,000 | $12,000 | $12,000 | $13,000 | $14,000 | $17,000 | $19,000 | $22,000 | $26,000 | $31,000 | $35,000 | $40,000 | $368,000 | $409,000 | $50,000 | $55,000 | $60,000 | $65,000 | $70,000 | $75,000 | $80,000 | $85,000 | $90,000 | $95,000 | $100,000 |
21 | ||||||||||||||||||||||||||||||||||||
22 | Income Before Taxes | -$15,000 | -$15,000 | -$15,000 | -$15,000 | -$15,000 | -$15,000 | -$15,000 | $3,440 | $5,300 | $7,160 | $10,700 | $14,240 | $17,600 | $24,000 | $30,400 | $42,200 | $55,000 | $66,800 | $92,400 | $117,000 | $142,600 | $167,200 | -$131,200 | -$466,600 | $284,000 | $312,400 | $340,800 | $369,200 | $397,600 | $426,000 | $454,400 | $482,800 | $511,200 | $539,600 | $568,000 |
23 | Taxes | -$1,148 | -$1,148 | -$1,148 | -$1,148 | -$1,148 | -$1,148 | -$1,148 | $263 | $405 | $548 | $819 | $1,089 | $1,346 | $1,836 | $2,326 | $3,228 | $4,208 | $5,110 | $7,069 | $8,951 | $10,909 | $12,791 | -$10,037 | -$35,695 | $21,726 | $23,899 | $26,071 | $28,244 | $30,416 | $32,589 | $34,762 | $36,934 | $39,107 | $41,279 | $43,452 |
24 | ||||||||||||||||||||||||||||||||||||
25 | EBITDA | -$16,148 | -$16,148 | -$16,148 | -$16,148 | -$16,148 | -$16,148 | -$16,148 | $3,177 | $4,895 | $6,612 | $9,881 | $13,151 | $16,254 | $22,164 | $28,074 | $38,972 | $50,793 | $61,690 | $85,331 | $108,050 | $131,691 | $154,409 | -$121,163 | -$430,905 | $262,274 | $288,501 | $314,729 | $340,956 | $367,184 | $393,411 | $419,638 | $445,866 | $472,093 | $498,321 | $524,548 |
26 | Total Yearly EBITDA | -$75,317 | $145,359 | |||||||||||||||||||||||||||||||||
27 | $194,040 | $3,095,400 | ||||||||||||||||||||||||||||||||||
28 | Overall Model Assumptions | $173,200 | $1,932,000 | |||||||||||||||||||||||||||||||||
29 | Consistent customer growth and scaling of different venues, artists, and more consumers | $85,000 | $1,006,000 | |||||||||||||||||||||||||||||||||